Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

Sequence
1) A procedure that returns all the columns in all the rows on a table
2) Check the existance of a procedure
3) Create procedure with OUTPUT Parameters
4) Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added
5) Execute Stored procedure with the parameter and assigned value
6) Get current IDENTITY value
7) Grant Permission of a procedure to PUBLIC
8) IDENTITY (1, 1)
9) IDENTITY [ (seed , increment ) ]
10) IDENTITY as PRIMARY KEY
11) Identity starting with -1000000
12) If you had two parameters, you could designate them
13) Multiple parameters can be passed in a comma-delimited list in the order they were declared
14) Now you explicitly enter a value for Identity column
15) Parameterization
16) Pass a constant to a function
17) Pass in three parameters
18) Pass in two parameter when calling a procedure
19) Pass variable to procedure output parameters
20) Procedure Based on input value
21) Procedure with two parameters
22) Retrieving the IDENT_CURRENT() Value
23) Returning a Computed Value as a Stored Procedure Output Parameter
24) Returning the Last Identity Value
25) Seed value was negative and the increment was positive
26) Select IDENTITYCOL
27) SQL Server chooses the highest number as its current seed for a positive increment value or the lowest for a negative increment v
28) SQL Server does not allow explicit values to be inserted into it
29) Stored procedure
30) Supplying Default Values
31) UniqueIdentifier
32) Using a Parameter in a WHERE Clause in a procedure
33) Using IDENTITY value
34) Using Identity during data insert
35) Using output parameter to return Values